package com.bsoft.mapper.business;

import org.apache.ibatis.annotations.Select;

import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

public interface ThirdLevelPubHosPerformanceAssessMapper {

    @Select("select distinct * from ${viewName}")
    List<Map<String, Object>> queryThirdLevelPubHosDic(Map<String, Object> req);

    @Select("select distinct BAH, ZYCS, RYSJ, CYSJ, YZBH, YZMC, YZFL, YZSX, JIXING, GYTJ, CFXQ, KZSJ, KZYSXM, KZYSBM, YZKSZXSJ, KSZXRYXM, TZSJ, TZYSXM, TZYSBM, YZTZZXSJ, TZZXRYXM, YZTS, YZBZSM, CYDYBZ, YLJGZYZJBZ " +
            " from ${viewName} where trunc(to_date(KZSJ,'yyyy-mm-dd hh24:mi:ss')) >=to_date(#{beginTime},'yyyy-mm-dd') " +
            "and trunc(to_date(KZSJ,'yyyy-mm-dd hh24:mi:ss')) <=to_date(#{endTime},'yyyy-mm-dd')")
    List<LinkedHashMap<String, Object>> queryHosInpatientOrder(Map<String, Object> req);
}
